﻿DROP TABLE IF EXISTS `open_group_promotion`;
CREATE TABLE `open_group_promotion` (
  `group_promotion_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `group_code` varchar(50) NOT NULL DEFAULT '',
  `group_name` varchar(50) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `price_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `discount` tinyint(3) NOT NULL DEFAULT '0',
  `start_time` int(11) unsigned NOT NULL DEFAULT '0',
  `end_time` int(11) unsigned NOT NULL DEFAULT '0',
  `user_rank` varchar(50) NOT NULL DEFAULT '0',
  `add_time` int(11) unsigned NOT NULL DEFAULT '0',
  `is_finished` tinyint(3) DEFAULT '0',
  PRIMARY KEY (`group_promotion_id`,`group_code`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;